UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lkIMPEhRPHA93setGs+ilm0+kjRj/zL9gnxtoosaqhQ='
WHERE
key_id = 'a8ae802ebec3b37b4a54dc9990b7ff5d438b67efc7d5d14771beda5033f4462c'
AND (
token = 'lkIMPEhRPHA93setGs+ilm0+kjRj/zL9gnxtoosaqhQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)