UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ncQ6Co8yEZyTw3gPtJwBHy135bokfbwDPNZMUbxR0BU='
WHERE
key_id = 'a06cc9dc1af4ffea0a829626bb64dc1bd0ebc446abfe4137028b0c64a9c414d0'
AND (
token = 'ncQ6Co8yEZyTw3gPtJwBHy135bokfbwDPNZMUbxR0BU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)