UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lrTrWu8dESaVNTr6YsHvS9tv2vc52HYTu2QhQrF/Uno='
WHERE
key_id = 'b8386d5fbf1e48ce3835530e8ce81d18b1782e8e63f371ec33c5ab048ff01f95'
AND (
token = 'lrTrWu8dESaVNTr6YsHvS9tv2vc52HYTu2QhQrF/Uno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)