UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k29u21dxI7UQcfx0OSbvmmr03FA3nsHfMZFwbuV5ZAs='
WHERE
key_id = '4d89b389729a9e6a6901386404a81a5cda7d0424d0660b0af14d43601ec0c4cc'
AND (
token = 'k29u21dxI7UQcfx0OSbvmmr03FA3nsHfMZFwbuV5ZAs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)