UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XhKHlVlYxXzDQbWXQFZ22Au6cxpEyicY0Jibvx7yxis='
WHERE
key_id = '50687e35c2d3d7f7e2a092c63d04a21d96fd994f8c652bcd7ec33106a68522e0'
AND (
token = 'XhKHlVlYxXzDQbWXQFZ22Au6cxpEyicY0Jibvx7yxis='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)