UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BZzKqngYvWCLHOIY32FJt/uGrwMB37fr2U+E1vYbSqA='
WHERE
key_id = 'ef5c72848b6246719c7cf1a541ee9a011a43cd4c2ce11089bac7db3e8e63cd5a'
AND (
token = 'BZzKqngYvWCLHOIY32FJt/uGrwMB37fr2U+E1vYbSqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)