UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mMJaYcDu5XgJbi7AWX4n8LYTZThnn+D020t7paukBgE='
WHERE
key_id = '78c91559b19ec2eb68129493b34a7be42c46d7df6d417945f97298496adb45b0'
AND (
token = 'mMJaYcDu5XgJbi7AWX4n8LYTZThnn+D020t7paukBgE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)