UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4m6XVRE4l2qL8zTsKGLdpS8joyUslJB/m3R01kBYdO8='
WHERE
key_id = 'd03969c063c6851b8a63e2b57123104544dbf73e5184d1ee07fc924caa4f198a'
AND (
token = '4m6XVRE4l2qL8zTsKGLdpS8joyUslJB/m3R01kBYdO8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)