UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cgHKqdzvEeY5x5mlzm9Sn7CIpf5y2DDFjy+6R+V0Etk='
WHERE
key_id = 'bae0897c4b5a19076910eb907df1688adc35652a6d49e4c60efe05fd0d0973b8'
AND (
token = 'cgHKqdzvEeY5x5mlzm9Sn7CIpf5y2DDFjy+6R+V0Etk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)