UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I/ziK0lszkV4Ean/86zKzeUyk0OrlEIIQRHzpsJz8n8='
WHERE
key_id = '6b9ae5e8f64df2ef1d7af5ee45c6e946395dd9c8de8e301c7f8e523b849381c7'
AND (
token = 'I/ziK0lszkV4Ean/86zKzeUyk0OrlEIIQRHzpsJz8n8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)