UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7LH+lV1WZnnS5hl46yOzNict1hkw5Ne/bAugdA0+fZo='
WHERE
key_id = '8b9b515e296cf001d0bd1a04517becccf3b45352f09319c4726f8c6162637207'
AND (
token = '7LH+lV1WZnnS5hl46yOzNict1hkw5Ne/bAugdA0+fZo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)