UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5ESUWu9ycvjypLbFF9KP30fB8Y6U29ZJfQx7ONiC57E='
WHERE
key_id = 'd9cd68a5707efdae34a86b01b9edc225784cc3fb32a4fb2edcb81c1ebb3ce530'
AND (
token = '5ESUWu9ycvjypLbFF9KP30fB8Y6U29ZJfQx7ONiC57E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)