UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GayP5dPkyWN8m63Km+THBo6BAejcqSvFKHasgFim+WI='
WHERE
key_id = 'cc17e705e6842a7453fcd8ad66a6015ed668a4737e9708ed059e943de2917b45'
AND (
token = 'GayP5dPkyWN8m63Km+THBo6BAejcqSvFKHasgFim+WI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)