UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4mAi0HsfmKbBcL3ibOBN/jlmv+jkaVgZxEs5xbrqT+g='
WHERE
key_id = '0148d9914592c85abd3b39297abe92ecb3f88a718c9f28e05c6c6bc3cc4265c0'
AND (
token = '4mAi0HsfmKbBcL3ibOBN/jlmv+jkaVgZxEs5xbrqT+g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)