UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BJ4PNdRor4RYUhW8jIjtCSpGLg4OTrnKA8WIMMAxtas='
WHERE
key_id = 'fe5a8fab8afdacd9e767e30c2e4838e6981f34a7f855c955ea53b9b3da0b3f19'
AND (
token = 'BJ4PNdRor4RYUhW8jIjtCSpGLg4OTrnKA8WIMMAxtas='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)