UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y8eYDfnHhGofkKzmKHJwH/RM19p6A6Wbu+ftAVgbMuw='
WHERE
key_id = 'e4b5fc2cd2232145430b0ec15d7e20313e673795ab964cea7c12c8c8f4dc0c2a'
AND (
token = 'Y8eYDfnHhGofkKzmKHJwH/RM19p6A6Wbu+ftAVgbMuw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)