UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dR9LpXbwM5ZVpLtjW4URyoupOLCoZPm2D3WQSbTDF2s='
WHERE
key_id = 'e045ece4af2b440c4de782ae7fc44827c049b573dfeae2884655d48ac5de9bc1'
AND (
token = 'dR9LpXbwM5ZVpLtjW4URyoupOLCoZPm2D3WQSbTDF2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)