UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dhoHtgjQCir+0KUz0H8/S2gViSKWKDzc3e9Si+F2vWU='
WHERE
key_id = 'bdc807ecdb924cb122b649cf4024ef9ee419df8690fc387fc0b6a5d144edd4b9'
AND (
token = 'dhoHtgjQCir+0KUz0H8/S2gViSKWKDzc3e9Si+F2vWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)