UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3YmVLuTdKnADniO/Kwv2nMAOe+F7yMnSH6cyRoiyddk='
WHERE
key_id = '6584a095ef56a6ef6276cfcfcc048b37e372496fe4eb451e4090cbab75f3c931'
AND (
token = '3YmVLuTdKnADniO/Kwv2nMAOe+F7yMnSH6cyRoiyddk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)