UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6VHHf8ktpDIEnH0j5RJV/achwTUIfpKwPjnDo5EO+R4='
WHERE
key_id = '7895b2bebe98d36f998cac31c5c3a7b0749a0ca10e985602f1db51357d5dc6fd'
AND (
token = '6VHHf8ktpDIEnH0j5RJV/achwTUIfpKwPjnDo5EO+R4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)