UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uOhPVONrUCS8ymCuhS80XnZOccILYmxPHCrqHZ/9Hwc='
WHERE
key_id = 'c8c85b8eaf9328f83065bff7717ba00f78c0ca19acd6159a6171d46c9f20aa6e'
AND (
token = 'uOhPVONrUCS8ymCuhS80XnZOccILYmxPHCrqHZ/9Hwc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)