UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dLiSV9xIMoOJMcDSUi+rAEhQP9nS4umOfjY1IcirzIc='
WHERE
key_id = '442b91c3975f7337835b5634fe3a81d54a6d1c25ad47ff200c5904216eeb4616'
AND (
token = 'dLiSV9xIMoOJMcDSUi+rAEhQP9nS4umOfjY1IcirzIc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)