UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6yCIaU32Siq25qZHvFNhUK7iB1gPdvYizVyiWQ+I+p8='
WHERE
key_id = '6e7e4509a2c29c49ae6e05b8ffecfcdeb0d59be3d6f47628834ae7c7b282e8a9'
AND (
token = '6yCIaU32Siq25qZHvFNhUK7iB1gPdvYizVyiWQ+I+p8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)