UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8LZvT5jFZo+ZIGOF0jdIAkf87D6rEdDGLofZH5QhuE='
WHERE
key_id = '029dc53ed4dadeee3073178e142ca25d78d9851e9a42f9ef229558cb96929418'
AND (
token = 'X8LZvT5jFZo+ZIGOF0jdIAkf87D6rEdDGLofZH5QhuE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)