UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VbCIvGM/SnEsUGHf1wWtEjMV4nIcNfJrX8StfOUL5pA='
WHERE
key_id = 'e712d58317fcbdc6e540cd862b3c84c137086d53a737f1cdf5f9fdbf25cbd8d1'
AND (
token = 'VbCIvGM/SnEsUGHf1wWtEjMV4nIcNfJrX8StfOUL5pA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)