UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i4JsbH8yi2qYTeZiENR4aVG+qekuF31Yr46yc3dNapI='
WHERE
key_id = '7296824fa4787272fe9dc68a46214d99f7cc390fdfbb2f32c94dda145b79a25e'
AND (
token = 'i4JsbH8yi2qYTeZiENR4aVG+qekuF31Yr46yc3dNapI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)