UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pxbfGBayxiDPm98syyY+dWV5cC0CoiQng8mxp2OiUUA='
WHERE
key_id = 'ca24533c8465fd525e9e6fb064f6b06bb16d8d0e49251712cd1942920478f877'
AND (
token = 'pxbfGBayxiDPm98syyY+dWV5cC0CoiQng8mxp2OiUUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)