UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5LMfcWrcYLD0RM9SYQRqNYEQaN4zgdCqBewv+1+7Zw='
WHERE
key_id = 'c28882866e07cf582b1ecae0153099b53ca032adab3dd448903bce8607c9850a'
AND (
token = '/5LMfcWrcYLD0RM9SYQRqNYEQaN4zgdCqBewv+1+7Zw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)