UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yZHtlgEsn9fQCbkGvCFereKtHj4W90E3/i+HX8IszF4='
WHERE
key_id = 'd48cf8da60d47be468de8d48da5853ce1067686b2ae31ddedc6437fa67cf4a4f'
AND (
token = 'yZHtlgEsn9fQCbkGvCFereKtHj4W90E3/i+HX8IszF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)