UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cX0Ccm7f8ejFFZMjygyVLZu6UByJgXNaw+Sg1bsKzB8='
WHERE
key_id = 'a1cd0bf9788ca97e42ef0551f707b7c57729868a3df436659c615955ad5f6597'
AND (
token = 'cX0Ccm7f8ejFFZMjygyVLZu6UByJgXNaw+Sg1bsKzB8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)