UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PRk4dagC6zIL/aJooJJ82h0ysog04AargRnCAuwM2pI='
WHERE
key_id = 'a27234221127fcae5dfca489866ebeb2489ea959165f35a4dff916a986efb3d1'
AND (
token = 'PRk4dagC6zIL/aJooJJ82h0ysog04AargRnCAuwM2pI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)