UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dEc9C8vj54aMuYjl5Zr0FYz7qNv96Da2R46MtSbcyo4='
WHERE
key_id = '1e2bd4768dbe1e6e01a5ea860e7bbc29306e5245e68a492ccc27f7f2ff1a6583'
AND (
token = 'dEc9C8vj54aMuYjl5Zr0FYz7qNv96Da2R46MtSbcyo4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)