UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cN0Crjr3Z2e7wIwruP9IYU4BKDrNTzqigW2nD2YYUYQ='
WHERE
key_id = '9ae5714022346ce1cf004dfa77aaab3833dee831e93ea416c07c518cd9789caa'
AND (
token = 'cN0Crjr3Z2e7wIwruP9IYU4BKDrNTzqigW2nD2YYUYQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)